load data

characterset AL32UTF8

infile '/app/czzx/dbtest/temp/extcard_20180524(9057170).unl'
infile '/app/czzx/dbtest/temp/extcarded_20180524(12645909).unl'

append into table card_info

fields terminated by '|'

trailing nullcols

(ACCOUNTNUMBER,PINNUMBER,BATCHNO,SEQUENCE,FACEVALUE,CURRENCY,CARDSTARTDATE,CARDSTOPDATE,HOTCARDFLAG,USESTATE,RECHARGECOUNT,TOPDISTRIBUTOR,CURDISTRIBUTOR,AMOUNT,APPDATE,OPRDATETIME,OPERATOR,TRADETIME,CHARGENUMBER,OPRTYPE,CARDRERVESTOPDATE,FRAGMENTNO,CALLINGNUMBER,DESTATTRID,OPRPRODATE,AUTHID,AUTHAVALIBLETIME,VOUCHERFLOW)
